package com.hotel.dao;

import com.hotel.entity.predetermine;


import java.sql.Timestamp;
import java.util.List;

public interface predetermineDao{
	
	//新增预订
	public int insertAll(predetermine predeterminePo);
	
	//分页和模糊查询
    public List<predetermine> pageFuzzyselect(String receiveTeamName,
	    		 String passengerName,int predetermineStateID,
	    		int start,int pageSize);
    
    //查询总条数
    public int countFuzzyselect(String receiveTeamName,
	    		 String passengerName, int predetermineStateID);
    
    //id查询
    public predetermine findById(Integer id);
    
    //根据 旅客id 来查询
    public List<predetermine> findLvKeId(Integer id);
    
    //根据 团队id 来查询 
    public List<predetermine> findTeamId(Integer id);
    
    //id删除
    public int deleteById(Integer id);
    
    //查询全部数据 无分页
    public List<predetermine> selectAll();
    
    //修改预订到时提示
    public int updateRemind(Timestamp arriveTime,Integer id);
    
    //修改预订状态
    public int updatePredetermineStateID(Timestamp arriveTime,Integer id);
    
}
